Dynamic Text Examples

The following examples will use this grid query:

To read Australian sales as a raw numerical value

DATA(0,0)

To read German Profit as a formatted string value

FormattedData(3,1)

To multiple Canadian sales by Canadian margin

Data(1,0) * Data(1,4)

To sum the sales column

TotalColumn(0)

To get the average profit across all countries

Average(DataSetColumn(1))

To read the label "France"

Label(1,2,0)

To find the row with the highest value in column 3

LookupMaxRow(3)

To find the country label with the highest net profit

Label(1,LookupMaxRow(2) ,0)

To read German sales as a raw numerical value

DATA(3,1)

To format German profit as currency with no decimals

Format("C0", Data(3,1) )

To find the value of sales for the last item in the grid

Data(LastRow(),0)

If Australian net margin is higher than Canadian net margin, write 'good', otherwise 'bad'

Iff(Data(0,3) > Data(1,3) ,"good","bad")

To write out which country has the highest profit and the amount of profit, formatted with in currency with no decimals

"The country with the highest profit of " + Format("C0", Data(LookupMaxRow(1),1)) + " is " + Label(1,LookupMaxRow(1) ,0)